package test;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.HashSet;
import java.util.List;
import java.util.Map;
import java.util.Set;

public class ServerFind {

	private static final Set<String> data = new HashSet<String>();
	
	private static final Set<String> server = new HashSet<String>();
	private static final Map<String, List<String>> sqls = new HashMap<String, List<String>>();
	static {
		put("gongfu_s1","INSERT INTO gongfu_s1.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 6087, 1, 4018, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s1","INSERT INTO gongfu_s1.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 80981087, 1, 882, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s1","INSERT INTO gongfu_s1.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 111380087, 1, 7546, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s3","INSERT INTO gongfu_s3.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 9466093, 1, 9016, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s15","INSERT INTO gongfu_s15.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 27600105, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s23","INSERT INTO gongfu_s23.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 40771124, 1, 2254, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s25","INSERT INTO gongfu_s25.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 31229125, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s32","INSERT INTO gongfu_s32.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 7422132, 1, 1323, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s45","INSERT INTO gongfu_s45.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 22358149, 1, 2646, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s50","INSERT INTO gongfu_s50.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 13092147, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s50","INSERT INTO gongfu_s50.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 22371147, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s50","INSERT INTO gongfu_s50.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 27370147, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s73","INSERT INTO gongfu_s73.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 24624173, 1, 3528, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s88","INSERT INTO gongfu_s88.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 1081188, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s88","INSERT INTO gongfu_s88.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 32990187, 1, 2254, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s89","INSERT INTO gongfu_s89.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 6505190, 1, 6272, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s98","INSERT INTO gongfu_s98.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 2336198, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s98","INSERT INTO gongfu_s98.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 20579194, 1, 2205, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s131","INSERT INTO gongfu_s131.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 20251235, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s131","INSERT INTO gongfu_s131.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 22513231, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s139","INSERT INTO gongfu_s139.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 921240, 1, 6762, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s139","INSERT INTO gongfu_s139.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 19151239, 1, 2254, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s143","INSERT INTO gongfu_s143.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 43242, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s156","INSERT INTO gongfu_s156.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 9490258, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s161","INSERT INTO gongfu_s161.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 23490261, 1, 10780, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s168","INSERT INTO gongfu_s168.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 30012268, 1, 4508, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s173","INSERT INTO gongfu_s173.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 11541273, 1, 882, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s178","INSERT INTO gongfu_s178.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 9278280, 1, 2254, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s181","INSERT INTO gongfu_s181.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 784281, 1, 6615, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s183","INSERT INTO gongfu_s183.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 18490282, 1, 2254, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s190","INSERT INTO gongfu_s190.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 890290, 1, 3136, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s191","INSERT INTO gongfu_s191.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 5714291, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s195","INSERT INTO gongfu_s195.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 14126292, 1, 2695, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s209","INSERT INTO gongfu_s209.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 8265309, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s215","INSERT INTO gongfu_s215.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 241317, 1, 1764, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s233","INSERT INTO gongfu_s233.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 21075333, 1, 6615, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s233","INSERT INTO gongfu_s233.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 21443332, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s262","INSERT INTO gongfu_s262.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 4385362, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s266","INSERT INTO gongfu_s266.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 156367, 1, 2254, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s278","INSERT INTO gongfu_s278.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 162378, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s288","INSERT INTO gongfu_s288.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 7793388, 1, 1764, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s296","INSERT INTO gongfu_s296.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 3544400, 1, 2254, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s306","INSERT INTO gongfu_s306.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 7866406, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s347","INSERT INTO gongfu_s347.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 4074447, 1, 6762, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s355","INSERT INTO gongfu_s355.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 10078455, 1, 4508, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s357","INSERT INTO gongfu_s357.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 400457, 1, 1764, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s361","INSERT INTO gongfu_s361.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 1705461, 1, 441, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s368","INSERT INTO gongfu_s368.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 9978468, 1, 3969, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s371","INSERT INTO gongfu_s371.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 3932471, 1, 882, 0, 0, 0, 0, 889, 1395158400);");
		put("gongfu_s374","INSERT INTO gongfu_s374.kf_cost_log (id,playerId,stype,gold,goldTicke,vipScore,goodsId,num,eventId,addTime) VALUES (0, 892474, 1, 2205, 0, 0, 0, 0, 889, 1395158400);");

		data.add("gongfu_s1");
		data.add("gongfu_s1");
		data.add("gongfu_s1");
		data.add("gongfu_s3");
		data.add("gongfu_s15");
		data.add("gongfu_s23");
		data.add("gongfu_s25");
		data.add("gongfu_s32");
		data.add("gongfu_s45");
		data.add("gongfu_s50");
		data.add("gongfu_s50");
		data.add("gongfu_s50");
		data.add("gongfu_s73");
		data.add("gongfu_s88");
		data.add("gongfu_s88");
		data.add("gongfu_s89");
		data.add("gongfu_s98");
		data.add("gongfu_s98");
		data.add("gongfu_s131");
		data.add("gongfu_s131");
		data.add("gongfu_s139");
		data.add("gongfu_s139");
		data.add("gongfu_s143");
		data.add("gongfu_s156");
		data.add("gongfu_s161");
		data.add("gongfu_s168");
		data.add("gongfu_s173");
		data.add("gongfu_s178");
		data.add("gongfu_s181");
		data.add("gongfu_s183");
		data.add("gongfu_s190");
		data.add("gongfu_s191");
		data.add("gongfu_s195");
		data.add("gongfu_s209");
		data.add("gongfu_s215");
		data.add("gongfu_s233");
		data.add("gongfu_s233");
		data.add("gongfu_s262");
		data.add("gongfu_s266");
		data.add("gongfu_s278");
		data.add("gongfu_s288");
		data.add("gongfu_s296");
		data.add("gongfu_s306");
		data.add("gongfu_s347");
		data.add("gongfu_s355");
		data.add("gongfu_s357");
		data.add("gongfu_s361");
		data.add("gongfu_s368");
		data.add("gongfu_s371");
		data.add("gongfu_s374");

		
//		server.add("gongfu_s103".trim());
//		server.add("gongfu_s123".trim());
//		server.add("gongfu_s143".trim());
//		server.add("gongfu_s145".trim());
//		server.add("gongfu_s15 ".trim());
//		server.add("gongfu_s165".trim());
//		server.add("gongfu_s183".trim());
//		server.add("gongfu_s185".trim());
//		server.add("gongfu_s213".trim());
//		server.add("gongfu_s215".trim());
//		server.add("gongfu_s23 ".trim());
//		server.add("gongfu_s233".trim());
//		server.add("gongfu_s25 ".trim());
//		server.add("gongfu_s253".trim());
//		server.add("gongfu_s3  ".trim());
//		server.add("gongfu_s306".trim());
//		server.add("gongfu_s313".trim());
//		server.add("gongfu_s315".trim());
//		server.add("gongfu_s319".trim());
//		server.add("gongfu_s326".trim());
//		server.add("gongfu_s333".trim());
//		server.add("gongfu_s334".trim());
//		server.add("gongfu_s335".trim());
//		server.add("gongfu_s345".trim());
//		server.add("gongfu_s346".trim());
//		server.add("gongfu_s347".trim());
//		server.add("gongfu_s45 ".trim());
//		server.add("gongfu_s5  ".trim());
//		server.add("gongfu_s55 ".trim());
//		server.add("gongfu_s65 ".trim());
//		server.add("gongfu_s73 ".trim());
//		server.add("gongfu_s75 ".trim());
//		server.add("gongfu_s83 ".trim());
//		server.add("gongfu_s85 ".trim());
//		server.add("gongfu_s95".trim());
		
//		server.add("gongfu_s109".trim());
//		server.add("gongfu_s119".trim());
//		server.add("gongfu_s139".trim());
//		server.add("gongfu_s14 ".trim());
//		server.add("gongfu_s159".trim());
//		server.add("gongfu_s173".trim());
//		server.add("gongfu_s176".trim());
//		server.add("gongfu_s196".trim());
//		server.add("gongfu_s199".trim());
//		server.add("gongfu_s203".trim());
//		server.add("gongfu_s209".trim());
//		server.add("gongfu_s214".trim());
//		server.add("gongfu_s223".trim());
//		server.add("gongfu_s234".trim());
//		server.add("gongfu_s249".trim());
//		server.add("gongfu_s262".trim());
//		server.add("gongfu_s266".trim());
//		server.add("gongfu_s302".trim());
//		server.add("gongfu_s309".trim());
//		server.add("gongfu_s314".trim());
//		server.add("gongfu_s322".trim());
//		server.add("gongfu_s329".trim());
//		server.add("gongfu_s34 ".trim());
//		server.add("gongfu_s351".trim());
//		server.add("gongfu_s352".trim());
//		server.add("gongfu_s353".trim());
//		server.add("gongfu_s354".trim());
//		server.add("gongfu_s355".trim());
//		server.add("gongfu_s381".trim());
//		server.add("gongfu_s382".trim());
//		server.add("gongfu_s383".trim());
//		server.add("gongfu_s384".trim());
//		server.add("gongfu_s385".trim());
//		server.add("gongfu_s386".trim());
//		server.add("gongfu_s387".trim());
//		server.add("gongfu_s388".trim());
//		server.add("gongfu_s389".trim());
//		server.add("gongfu_s390".trim());
//		server.add("gongfu_s391".trim());
//		server.add("gongfu_s392".trim());
//		server.add("gongfu_s393".trim());
//		server.add("gongfu_s394".trim());
//		server.add("gongfu_s395".trim());
//		server.add("gongfu_s396".trim());
//		server.add("gongfu_s397".trim());
//		server.add("gongfu_s398".trim());
//		server.add("gongfu_s399".trim());
//		server.add("gongfu_s400".trim());
//		server.add("gongfu_s401".trim());
//		server.add("gongfu_s44 ".trim());
//		server.add("gongfu_s69 ".trim());
//		server.add("gongfu_s79 ".trim());
//		server.add("gongfu_s89 ".trim());

//		server.add("gongfu_s10 ".trim());
//		server.add("gongfu_s106".trim());
//		server.add("gongfu_s116".trim());
//		server.add("gongfu_s156".trim());
//		server.add("gongfu_s16 ".trim());
//		server.add("gongfu_s170".trim());
//		server.add("gongfu_s190".trim());
//		server.add("gongfu_s240".trim());
//		server.add("gongfu_s256".trim());
//		server.add("gongfu_s276".trim());
//		server.add("gongfu_s296".trim());
//		server.add("gongfu_s30 ".trim());
//		server.add("gongfu_s303".trim());
//		server.add("gongfu_s304".trim());
//		server.add("gongfu_s316".trim());
//		server.add("gongfu_s320".trim());
//		server.add("gongfu_s323".trim());
//		server.add("gongfu_s324".trim());
//		server.add("gongfu_s337".trim());
//		server.add("gongfu_s338".trim());
//		server.add("gongfu_s341".trim());
//		server.add("gongfu_s342".trim());
//		server.add("gongfu_s343".trim());
//		server.add("gongfu_s344".trim());
//		server.add("gongfu_s348".trim());
//		server.add("gongfu_s349".trim());
//		server.add("gongfu_s350".trim());
//		server.add("gongfu_s36 ".trim());
//		server.add("gongfu_s40 ".trim());
//		server.add("gongfu_s50 ".trim());
//		server.add("gongfu_s60 ".trim());
//		server.add("gongfu_s64 ".trim());
//		server.add("gongfu_s76 ".trim());
//		server.add("gongfu_s96 ".trim());
		//1026
//		server.add("gongfu_s101".trim());
//		server.add("gongfu_s111".trim());
//		server.add("gongfu_s127".trim());
//		server.add("gongfu_s131".trim());
//		server.add("gongfu_s147".trim());
//		server.add("gongfu_s151".trim());
//		server.add("gongfu_s17 ".trim());
//		server.add("gongfu_s171".trim());
//		server.add("gongfu_s191".trim());
//		server.add("gongfu_s228".trim());
//		server.add("gongfu_s248".trim());
//		server.add("gongfu_s257".trim());
//		server.add("gongfu_s261".trim());
//		server.add("gongfu_s268".trim());
//		server.add("gongfu_s27 ".trim());
//		server.add("gongfu_s281".trim());
//		server.add("gongfu_s287".trim());
//		server.add("gongfu_s288".trim());
//		server.add("gongfu_s297".trim());
//		server.add("gongfu_s301".trim());
//		server.add("gongfu_s305".trim());
//		server.add("gongfu_s307".trim());
//		server.add("gongfu_s308".trim());
//		server.add("gongfu_s317".trim());
//		server.add("gongfu_s321".trim());
//		server.add("gongfu_s325".trim());
//		server.add("gongfu_s327".trim());
//		server.add("gongfu_s328".trim());
//		server.add("gongfu_s336".trim());
//		server.add("gongfu_s356".trim());
//		server.add("gongfu_s57 ".trim());
//		server.add("gongfu_s61 ".trim());
//		server.add("gongfu_s7  ".trim());
//		server.add("gongfu_s81 ".trim());
//		server.add("gongfu_s91 ".trim());

		server.add("gongfu_s118".trim());
		server.add("gongfu_s128".trim());
		server.add("gongfu_s133".trim());
		server.add("gongfu_s138".trim());
		server.add("gongfu_s153".trim());
		server.add("gongfu_s168".trim());
		server.add("gongfu_s178".trim());
		server.add("gongfu_s188".trim());
		server.add("gongfu_s204".trim());
		server.add("gongfu_s210".trim());
		server.add("gongfu_s218".trim());
		server.add("gongfu_s219".trim());
		server.add("gongfu_s224".trim());
		server.add("gongfu_s239".trim());
		server.add("gongfu_s243".trim());
		server.add("gongfu_s244".trim());
		server.add("gongfu_s278".trim());
		server.add("gongfu_s310".trim());
		server.add("gongfu_s318".trim());
		server.add("gongfu_s330".trim());
		server.add("gongfu_s339".trim());
		server.add("gongfu_s340".trim());
		server.add("gongfu_s357".trim());
		server.add("gongfu_s358".trim());
		server.add("gongfu_s38 ".trim());
		server.add("gongfu_s48 ".trim());
		server.add("gongfu_s68 ".trim());
		server.add("gongfu_s8".trim());
		server.add("gongfu_s88 ".trim());
		server.add("gongfu_s98 ".trim());


	}
	
	public static void main(String[] args) {
		for (String e : data) {
			if (server.contains(e)) {
				for (String ee : sqls.get(e)) {
					System.out.println(ee);
				}
			}
		}
	}
	
	public static void put(String db, String sql) {
		List<String> list = sqls.get(db);
		if (list == null) {
			list = new ArrayList<String>();
			sqls.put(db, list);
		}
		for (String e : list) {
			if (e.equals(sql)) {
				return;
			}
		}
		list.add(sql);
	}
}
